<?
require("config.php");

$label = "Newsletter Subscription List";


$table="med_subscription";

	$Query="SELECT 
	id,
	date,
	name,
	email 
	FROM $table ORDER BY id DESC";

	$r=myQuery($Query);

require($rela_path . "inc/header1.php");
?>
<br>
<table width="90%" border="0" align="center" cellpadding="1" cellspacing="1" class="tb">   
<tr class="tbheader"> 
    <td width="2%"> 
      <div align="center">No.</div>
    </td>
    <td width="10%"> 
      <div align="center">Date</div>
    </td>
    <td width="40%"> 
      <div align="center">Name</div>
    </td>
    <td width="33%"> 
      <div align="center">Email</div>
    </td>
    <td width="15%"> 
      <div align="center">&nbsp;</div>
    </td>
  </tr>



<?
if ($r){	
	for ($i=0;$i<count($r);$i++){?>
  <tr class="tbcontent1"> 
    <td align="right"><?print($i+1)?></td>
    <td><?print($r[$i][1])?></td>
    <td><?print($r[$i][2])?></td>	
	<td><?print($r[$i][3])?></td>	
    <td align="center"><a href="subscription_list_detail.php?id=<?print($r[$i][0])?>">Detail</a></td>
  </tr>
<?}
	
}?>





</table>
<br>
<br>
<?
require($rela_path . "inc/footer1.php");
?>
